import pymysql
from dotenv import load_dotenv
import os

def get_connection():
    return pymysql.connect(
        host="localhost".encode('utf-8'),
        port="3306".encode('utf-8'),
        user="root".encode('utf-8'),
        password="69296616".encode('utf-8'),
        database="dbkeshe".encode('utf-8'),
        cursorclass=pymysql.cursors.DictCursor
    )